Show Table Constraints
SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS;
To print in a readable format use the following:
SELECT constraint_name, table_name FROM user_constraints WHERE constraint_name NOT LIKE 'SYS%';
Description
View the constraints of the database.